package vip.xiaonuo.smzq.modular.jsxm.mapper;

import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import vip.xiaonuo.smzq.modular.jsxm.entity.JsxmYfkcYfzycl;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Mapper;

import java.util.List;

/**
 * 建设项目—矿产资源组合 Mapper
 *
 * @author sqq
 * @since 2024-05-24
 */
@Mapper
public interface JsxmYfkcYfzyclMapper extends BaseMapper<JsxmYfkcYfzycl> {
    @Select("SELECT CONCAT(kslx, ',', kspj) AS kslxpj FROM yf_jsxm_yfkc_yfzycl where jsxmbh=#{jsxmbh} GROUP BY kslxpj ")
    List<String> getKslxpjList(String jsxmbh);
    @Select("SELECT zycllx FROM yf_jsxm_yfkc_yfzycl where jsxmbh=#{jsxmbh} and kslx=#{kslx} and kspj=#{kspj} GROUP BY zycllx")
    List<String> getZycllzList(@Param("jsxmbh") String jsxmbh, @Param("kslx") Integer kslx, @Param("kspj") Integer kspj);

}
